How to update BigCommere metafields in bulk
In a practical scenario of managing the BigCommerce store, It is often required to update metafields in bulk. We have created the CSV update tool to solve that problem. With our CSV update tool you can update all of bigcommerce metafields under one resource type in one click. Updating data using a CSV file is one of the easiest methods available out there. Even if you are a beginner, you can manage csv files using your favourite spreadsheet tools(like, MS excel, Openoffice Calc etc.) you can use the update tab of the app and start exporting the data in the CSV format.
Understanding the template
| Field Name | Type | Description | Example value |
|---|---|---|---|
| resource_id | number | The BigCommerce id of the resource (For example, product id) | 120 |
| id | number | The BigCommerce id of the metafield | 12 |
| key | string | The key of the metafield | Name |
| value | string | The value of the metafield | Ronaldo Cristiano |
| name | string | The name of the metafield to understand what it is | Employee Name |
| description | string | The description of the metafield to briefly tell what it is | field to store the Employee Name |
| namespace | string | The namespace of the metafield. Example - Multiple employee names can be in the same namespace | Employee |
| permission set | string | The permissions allowed on the metafield | - app_only Private to the app that owns the field - read Visible to other API consumers - write Open for reading and writing by other API consumers - read_and_sf_access Visible to other API consumers, including on storefront - write_and_sf_access Open for reading and writing by other API consumers, including on storefront |
Steps to update the metafields in Bulk
- Step:1 Begin by exporting your current data; you'll find the download option in the "Export" tab.
- Step:2 Modify the entries within this downloaded sheet, or create a new one. Remember, both the resource ID and metafield ID are essential for each entry you wish to update.
- Step:3 Once your sheet is ready, Upload your modified sheet by clicking on the "Please select a file" button.
- Step:4 Initiate the update by clicking the dedicated "Update" button.
- Step:5 A notification will pop up. To track the status of your update, click the "Progress" button located on the right side of the page.
- Step:6 To confirm your changes, navigate to the "Browse" tab and search using either the metafield ID or SKU.
The user interface is displayed here.
